Two children are among the at least six killed after a tourist submarine sank in the Red Sea off the coast of Egypt.