The CO2 content varies between water companies, but after it leaves the tap it will stabilize around 3 ppm after a day. So if your tap water has lots of CO2 in it, it will outgas until it is lowered to 3 ppm and the pH will rise accordingly. If your tap water has less CO2 than 3 ppm, the pH will drop as CO2 is absorbed.
That is why if you want to test your tap water's pH you need to let it sit for 24 hours so the CO2 reaches its normal levels. Testing it directly out of the tap is not accurate at all.