The legendary musician, who has been friends with David, 50, and Victoria Beckham, 51, for over 30 years, treated Brooklyn and Nicola Peltz to a swanky lunch at fancy La Guerite beach club in the South of France