Mark Cavendish’s bid for the yellow jersey ended in a heap as the Manxman tumbled to the tarmac in a dramatic conclusion to the opening stage of the 101st Tour de France in Harrogate.