Shocking bodycam footage shows the moment a drunk football supporter wielded a traffic cone at a wall of police.