Cepheid metallicity in the Leavitt law (C-MetaLL) survey – III. Simultaneous derivation of the Gaia parallax offset and period–luminosity–metallicity coefficients. Issue 3 (8th February 2023)