The average premium paid for private comprehensive motor insurance in the second quarter of 2023 was £511, the highest since records started in 2012.