[RajatPawar]

I assume the ID field is auto incrementing. So an easy solution for you now is, add a field called 'deleted', set it to 1 when you want to delete an apartment, and just rewrite over it when you want to create a new one over it. This is the one of the most easiest solutions you can manage given you have already scripted it, right? This also provides the advantage of being able to undo any deletions you did by mistake.