Six people including children have been killed when their tourist submarine sank in the Red Sea off the coast of Egypt.