Discussion on answer by markp: Can two mysql SELECT FOR UPDATE FROM mytable WHERE .. IN (..) deadlock?

Imported from a comment discussion on https://dba.stackexchange.com/questions/182963/can-two-mysql-select-for-update-from-mytable-where-in-deadlock/182978#182978