Put it at the peak of a fail, right as the mistake is revealed, then let the scene settle with awkward crickets for the embarrassed moment that follows. For a bigger shock, place a shocking sound effect just before it so the scream becomes the payoff rather than the setup.