York Valkyrie make it five straight wins at the end of the season but cannot secure the huge win they needed to take second place in Super League.