York Knights came agonisingly close to another seismic Betfred Super League shock as they pushed Wigan Warriors to the brink in a nail-biting 23-22 defeat.