Dramatic footage shows moment gunman's four-hour stand-off ends as armed cop screams orders