how to weekly once increment id

Question

I want  PSSR/B1097/REO/B100,  ARPA/B146  get data to database

After Split the PSSR/B split 1097 and  REO/B separate  100,

1097  value increment 1098

100 Value  Increment 100

after this valuePSSR/B1098/REO/B101 insert Batchid  to database this result 

another one Example:  ARPA/B146  this id increment  create ARPA/B147