The file_id of 1074 is fine, this will be the auto increment from the files table so I assume you have other files with previous numbers.
It should trigger on a user delete also though. I'd like to take a closer look, can you raise a ticket with access to the install and I'll run some checks?