Hi Swarup

Order or records in a database query or table can be defined using specific column of type that can be sorted. This assumption is not mandatory though and can be ignored.

The column to sort is usually of integer type. Sort by this column, e.g. by clicking on the header and will be ordered. 

Primary key is a good default sorting column which in addition is autoincremented so its sorting is out of the box.

In KEXI you can edit values even in this column so to reorder records you have to edit the numbers accordingly.

E.g. consider table with the primary key column and some text column.

Before:

1 a

2 b

3 c

After renumbering:

1 inserted row

2 a

3 another inserted row  

4 b

5 c

As you see it is renumbering as follows: 1->2, 2->3, 3->5.

What you ask for looks like a support for spreadsheet-like behovior for tables/queries where records are strictly sorted and the order is preserved. This is something I've been thinking about as extension, special mode for the tabular view. Feel free to file a wish for it at https://community.kde.org/Kexi/File_a_bug_or_wish.