Sir Elton John appeared on stage at the Attitude Awards after opening up about his health struggles in recent years and he took a swipe at Elon Musk