At least four people were killed when a missile hit a hospital supported by Medecins Sans Frontieres (MSF) in northern Yemen, the aid agency says.