Six people are dead and dozens of others have been rescued after a tourist submarine sank in the Egyptian Red Sea.