Money spent on sports clubs and gyms jumped last month as consumers turned to more affordable ways to enjoy an active summer, data has shown.