Yorkshire put up spirited showing on Tier 1 debut but are outdone at the last in thriller