The six people who died after a tourist submarine sank in the Red Sea off the coast of Egypt were all Russians, Egypt's Red Sea governate has said.