Insert query result into database row
You need the AUTO_INCRMENT default for your id field, so:

ALTER TABLE `payment_transactions_daily_facts`
CHANGE COLUMN `id` `id` INT(11) NOT NULL AUTO_INCREMENT FIRST;


Then, next time you run your INSERT, the system will create an auto incremental id for you automatically.