A retired British couple have been killed in a scuba diving accident at a site where they had dived more than 60 times.