Ad sequential number

I have a Query to find the highest value in a field. I just want to populate another field with the next sequential higher number. Can someone point me in the right direction? I can’t find it in the helps.
Nordite