Resilient York Valkyrie shock Wigan Warriors to win Women's Super League title