The Salesforce connection sequence (order) is important for use cases where you are creating master, child and lookup relationships between Salesforce records. For example, if one connection is creating a Salesforce Account and another one is creating multiple Contacts, the Account will be created first i.e. lower sequence number and the Contacts would come after at a higher sequence because we need to have the Account available on Salesforce when we are creating Contacts related to the Account. If both of the objects are not related the sequence is not important.
For any questions, please contact us - firstname.lastname@example.org