it is possible to insert record in between the two records?

A table is an unordered recordset. The position of a record in the table is not relevant unless you impose an order on it. That is quite different from a spreadsheet, as you suggest.

If the order is important, you will need to apply the order in a query or in a form, not in the table.

You can't always get what you want, but if you try sometimes you may just get what you need - Rolling Stones