Despite being friends with David and Victoria Beckham for over 30 years, Sir Elton John has delivered a bombshell show of support for his godson Brooklyn and wife Nicola Peltz