Using lastInsertId() inside a transaction, can you be sure that the ID will not be taken from another transaction in the global sense?

Question

PHP

$db->beginTransaction();
        /*****/
        $sql = "INSERT INTO products (name, price) VALUES (:name, :price)";
        $sth = $db->prepare($sql);
        $sth->execute(
          array(
            ':name'=>$product['main']['name'],
            ':price'=>$product['main']['price'],
          )
        );
        // Получаем id последней вставленной записи
        $idProduct = $db->lastInsertId();

        /*****/
        foreach ($product['attributes'] as $attribute) {
          $sql = "INSERT INTO productAttribute (idProduct, nameAttribute) VALUES (:idProduct, :nameAttribute)";
          $sth = $db->prepare($sql);
          $sth->execute(
            array(
              ':idProduct'=>(int)$idProduct,
              ':nameAttribute'=>$attribute['attribute'],
            )
          );
        }

Answer 1

lastInsertId() is unique per table
Why is PDO::lastInsertId returning the wrong ID on frequent database inserts?

Answer 2

Yes, for mysql it is possible.
https://dev.mysql.com/doc/refman/5.7/en/mysql-inse...
That is, the last generated ID in the current connection is taken.