Amateur football club wins £1m Lotto prize after 30 years of trying