Just to make sure I have repeated the process which is:
The first image was imported from a camera SD card and has not ben modified in any way. I then exported it.
The 2nd image was the first image but with auto applied which has made minimal change and then I exported again.
The 3rd image was when I took the first image (from the SD card) via the "edit in affinity Photo 2" option from exposure X7, it then displayed as shown (in Affinity Photo 2) which I then simply exported as a jpg.
I can understand the original colour cast as this was taken in a room with a warm LED ceiling light. I think the auto could not do much about it because there was no strong black or white for it to anchor to, but when it went into Affinity Photo 2 and this immediately changed the color, particularly the purple, this is what I do not understand.