Royal Navy wardship HMS Diamond has shot down a missile fired by the Iranian-backed Houthis from Yemen.