Migrant’s bid to smuggle himself from France to UK backfires as he realises lorry is set for Germany