Put it at the exact moment the trick is revealed, after the setup has played out and before the reaction shot. Lead into it with Dun Dun Dun for suspense, then let the reveal land, and follow it with the Classic Error Sound to underline that the victim was fooled.