The former Tour de France winner brought the curtain down on his career on an emotional final stage of the Tour of Britain, hosted by his hometown