When you slap someone's butt, and they squeak (like a trumpet) Hence, slap trumpet.
The guys kept pulling slap trumpets on their teamates.