Edinburgh and Leeds will host the opening stages of the men's and women's Tour de France in 2027, with the UK Government saying it will be "the most accessible major sporting spectacle ever held in Britain".