Fireworks, a concert and a touch of royalty were wheeled out for the 40th birthday celebrations of the Sydney Opera House.