The problem seemed to be in MySQL’s phpmyadmin config file PersistentConnections set to FALSE which resulted in a new CONNECTION_ID every time a query was issued – therefore rendering SELECT LAST_INSERT_ID() ineffective.
more info in the subsequent topic Every query creates a new CONNECTION_ID()
Also thanks dnagirl for help