As far as I understand, Liquibase execute the changesets according to the order they are written in the change log. I want the changeset to be ran in another order. Is there any way to change the execution order of changesets?
A prompt response for my question would be highly appreciated.
The order of your changelog in Liquibase is the order that changes should be deployed (executed) if needed.
Liquibase relies on you to setup the correct order.
In order to use a dynamic order that matches the current situation you should use a compare & sync tools that will generate the relevant DDL based on your source control repository and your target environment.
Dbmaestro (for which I work) offers this feature