Thanks Jasonj for your time and help.
It was number 4 on your list. a bad coil.
I got a new diagnostic tool and it showed number 4 cyl and the counts of misfiring on that cyl. The misfiring count just kept going up. I swapped the ignition coil from cyl 4 to cyl 1 and the misfire count shifted to cyl 1.
Fitted 4 new Bosch ignition coils and rechecked on the scan tool, no more misfires detected and all fault codes have disappeared/gone.
I put the 3 old working ones in the boot with a small tool kit for next time.
For any one reading this that are short for cash you can just change the bad one for a new one although the others are just as old so it's good practice to change them all once confirmed the coil pack is faulty.