York Valkyrie become the first side to win the Women's Super League three times after an incredible defensive effort thwarts favourites Wigan.