Implementing a stack rank function?

What is a "stack rank"? Can you give an example with specific values before and after the update?

Basically I want to keep all records in a table ordered, so if i had 10 items, they would be numbered 1, 2, 3, ...10.  If user inserts a new record and assigns it as 5, then existing 5, 6, 7,... 10 would all get incremented by 1.

You posted the question about numbering sorting and number records in a table a number of years ago.  Did you ever get a response or figure out how to do it?  I have been looking for a formula to build ranking on reports with no luck.

Summary reports can essentially do ranking because if you do a summary report but basically break on every record, you can have a field with a formula value of 1 and display that as running totals down the page.  So they self number from 1 to .. whatever. 

I will try that, but I think that will take up a lot of room on the screen, and certainly not as compact as being able to identify a field on any record as a placeholder or rank.  It just surprises me that as Quickbase already counts the number of records in a report (displays the number of records in the report) there isn't a checkbox or something on report set up that allows for row numbering.