York Knights weathered a late Sheffield Eagles storm to all but confirm their place in the Betfred Championship play-offs, with a thrilling 26-24 victory.