Prince William's cousin Zara Tindall was a red carpet bombshell in a sheer evening dress alongside her husband Mike at the 2024 Beauty Awards at the Honourable Artillery Company in London