Women’s football in Scotland is booming with attendance at matches increasing and enthusiasm growing for the match-day experience, research shows.