Sequence of OBX segment is not correct

I am using Chameleon to create HL7 file. Everything was working fine until I encountered large number of OBX segments in in one group. My problem is sequence in which my vmd populating hl7 file with OBX segments is not correct. If I have 10 sequential OBX segments in one group, OBX with setId 6-10 are above then those having sequence from 1-5. In DB tables data is present in sequential manner, now I dont know how to configure my vmd to get those segments im ascending setIds.
Right now I am getting something like

OBX|6|
OBX|7|
OBX|8|
OBX|9|
OBX|10|
OBX|1|
OBX|2|
OBX|3|
OBX|4|
OBX|5|

while I want

OBX|1|
OBX|2|
OBX|3|
OBX|4|
OBX|5|
OBX|6|
OBX|7|
OBX|8|
OBX|9|
OBX|10|

can someone help me how to deal with it?

I have figured out the reason but not able to find solution yet.
Problem is I have added a group for repeating OBX. As Chameleon itself create columns of group, it creates three columns (message_id(varchar2), parent_id(varchar2), group_id(varchar2)) within a group. Now all of these are of type VARCHAR2. I have to add a row to group whenever I add in OBX table. Now when total OBX in one message increase to 10, ‘group_id’ column of Group table starts rearranging itself on basis of its varchar2 type

In GROUP table its group_id arrangement is something like

12
11
10
1
2
3
4
5
6
7
8
9

and the same way vmd capture OBX rows. That’s why my hl7 file carries incorrect sequence of OBX. Now I cant change the arrangement in which data is stored in tables after insertion, is there any way to customize selection of data into hl7 file, I mean I can use ‘order by’ in its default query?