‘Big wave’ of support across the country tipped as England Women edge past Spain in ‘brilliant advert for women’s football’