Put it at the end of a build-up, after a suspense cue such as Dun Dun Dun, so the reveal lands as the payoff. Follow it with MLG Air Horn only when the moment is big enough to deserve a second cheer, otherwise let the reveal stand alone.
About this sound
This is a short, bright ta-da flourish lasting just over a second, with rising notes that land on a cheerful final chord. It feels triumphant and a little theatrical, like a tiny fanfare announcing something worth seeing. The sudden lift makes a reveal feel bigger, sillier and more satisfying, turning an ordinary moment into a small celebration.