External DVD on Macbook Pro 2018 with multiport adapter
It seems solved by updating Mojave to 10.14.6.

Audio CDs work and most data CDs/DVDs work as expected.

Only RW disks seem difficult to read, but this seems a completely different problem.
So it seems that using a multiport adapter can help connecting a USB CD/DVD drive.