Is it possible to display the most recent 5,000 items in a list using the ID ? If the answer is yes, then how ? Also, is the ID inherently have an index ?
I noticed when I tried to create an Index on ID it was not an available field.
if the concern is just to get the most recent items, get it on the basis of Created date.
5000 is the list item limit for a view, or as Microsoft puts it, "approximately 5000". (Source) So in theory the number is achievable.
ID has an incremental number as its value, but it is not available as a column to be shown. If you want to use it, you may achieve it by creating a calculated column which uses the value of
[ID]. Bear in mind, that when a list item is removed, its index value becomes empty.
You may want to make a view that shows items sorted by Created or Modified date to see the recent items in the list according to that. I wouldn't rely on ID's alone because they increase as time goes by but don't get replaced or re-used when users delete items in the list.
According to this the built in ID column is already indexed as it is a system field(column). https://msdn.microsoft.com/en-us/library/ff798465.aspx