Video showing moment that ballistic missile destroyed by Saudi-led coalition which says it was launched by Houthis to target Riyadh .