A New Years Eve ball in one of York’s most historic venues has sold out.