Thanks for reading.
Private and public IP don't change the egress cost. Even if you use public IP, with Cloud Run Cloud SQL connector (for example) or with the Cloud SQL proxy, if the traffic stays in the region, you won't pay egress fee.
If you leave the region, with public or private IP, you will pay egress. No difference.