This sound effect can be found on RH 76/77, which was made by Robert Hall Productions.
https://soundeffects.fandom.com/wiki/File:Robert_Hall,_Factory_Horn...Ambulance_Bell_(British).ogg