Does the horn have to work with the ignition off?

For an MOT yes, for SVA a horn is not required.

HTH,
Rich.