Could you say why you wish to reset it please?
The transaction ID just happens to be an integer that starts at 1 in a new database and increases as transactions are added across all accounts. However, it's not really a "counter". Just regard it as a reference identifier.