The hopper script always sorts leads as they are pulled to go into the hopper, and the campaign Lead Order field will determine how it sorts them. By default, the database will sort them by the order in which they were inserted, but it's not difficult to change that.
If you don't sort by DOWN or UP lead order, you can use the LEAD_ID(which is insertion order) as a Secondary Order for the campaign.
Glad we could be of some help