Put it at the climax of a goal sequence, after the shot and the crowd reaction, so it closes the play. Lead in with the Inception Horn for a rising build, then let the goal horn take the final beat before cutting to the celebration.