How to determine a row id number to each row of a filtered data master?

Mario shared this problem 2 years ago

Not a Problem

It is quite simple to associate a field id autoincrement to each record of a table (in a table of n records), but when I have to restrict the result set to k occurrences of the n, I would have a field or a way to show sorted id numbers, from 1 to k . How can I do that?