A shorter answer:

    ... WHERE MID(server, 2) BETWEEN 89 AND 110

Or, if you need to limit to the "C" set of servers:

    ... WHERE MID(server, 2) BETWEEN 89 AND 110
          AND server LIKE "C%"