In SQL can we insert a record between two records using SQL syntax?

Answer 1

Nope.... In relational database, records are not ordered when stored. If you retrieve it, it can come out in ANY order.

The only thing you can do is to define a column as a key and use the ORDER BY clause to sort it when you retrieve them.