Your query retrieves the first ten rows from your table. What you need to do now is to put a link for the "next page" which calls the same function, but recovers the next ten rows. One way would be to pass the page number, or the starting row, into the
view_sold() function and have your link or Ajax call provide it. Once you have that, obviously you can add links to previous page, first page, and so on.
You also need to look at moving from the old-style (and no longer part of the language) mysql calls and use something like mysqli or, my preference, PDO.