A British tourist has died after being found unconscious underwater while on a diving expedition to a shipwreck site off the coast of Cyprus.