Man killed in shoot-out after opening fire on police officers