WordPress doesn’t record the visit statistics in the database. If you want to show top visited categories, you must then record statistics somewhere.
What’s why there are plugins designed to fill out this need.
Of course, you can write your own code to record visits in the database. This will be a good starting point.