Is there any way to reset record Id for all records?

Does the table have any relationships?

yea, i guess otherwise I could just make a new table and copy everything over

So, no you cannot reset the Record ID#.  I was going to suggest to copy the table into the same app without data and it would renumber starting at 1.

I might just make a new field and renumber that way then. Do you have a quick way suggestion for that? I might export everything to a spreadsheet and filter by date created then number them there then import back into QB into the new numbering field, or is there a quick formula way to do that?

Huh? how are you gong to auto generate new numbers for new records.  What is your goal here?  While I personally dislike this, you can auto number with a formula like 

[Record ID#] - 40000

well, basically to start the numbering over somehow because a lot of data has been deleted at some point probably when the app started out and people testing the app. I don't need the numbering at the moment but will use them in the future for basic record identification using numbers. 

Will the "[Record ID#] - 40000" keep the same order from date created???

Yes, the Record ID# advances by 1 number every time a record is created.  So the sequence is [Date created]  It's like a car odometer that can never be rolled back. It can only drive in forward gear. 

I may have miscommunicated somewhere sorry - I'm trying to re-number starting with my earliest record and not just new records. So, if my earliest(created in 2017) RID as of right now starts at 21,567, i want it to be 1. Then number from there by creation date, so the [Record ID#] - 40000 would make my first record number something negative.

[Record ID#] - 21,566

e.g. 21,567 - 21,566  will = 1.