There should be no expectation that the Northern Ireland Protocol negotiations will lead to a "perfect" solution, a former prime minister has warned.