Optimizing paging in MySQL

An interview question, how to do paging when there is a large amount of data in the MySQL table. . . . At that time, I only knew that tables could be split when the amount of data was large, but I didn’t know what to do without splitting tables. . . . Alas, who asked the agent to only have a few pieces of data and a simple limit and offset to completely hold it down (face covering)