Running the following command against MYSQL Server v8.0.32
creates a dump without error messages, which look like this:
As one can see the VALUES part uses an incorrect order of columns. Trying to import such a dump, obviously, fails directly with "DUPLICATE KEY".
Observation: The order of the VALUES is the alphabetical order of the column names not the one specified in the CREATE TABLE statement.
(Note: Running the same command using mysqldump from mysql works flawlessly)