Screenwriter Frank Cottrell Boyce has won the Carnegie medal for his first novel, Millions, saying that he was "chuffed to bits" to have won Britain's oldest children's award.