At least three crew members have been killed and six others rescued after a cargo ship was attacked by Yemen's Houthis and sank in the Red Sea, a European naval mission says.