Transporter carrying luxury cars worth more than £1m tips over on dual carriageway