I have multiple users concurrently inserting data can the last_insert_id be trusted?

The last_insert_id reflects the id of the last record inserted by that connection. I've never seen evidence, direct or otherwise, that it isn't reliable.