Why do Bayern Munich play the can-can music when they score?

The German giants have long played goal music during games, but the origins of their selection are murky