The Tour de France is set to begin in Scotland for the first time in 2027.