Prime minister says he ‘deeply regrets’ any offence caused by him taking leave during fires, and he will return to Sydney