Two children have been killed and five remain trapped after a tourist submarine sank in the Red Sea off the coast of Egypt.