CREATE TABLE table_204_820 (id NUMBER, "date" CLOB, "constituency" CLOB, "c/u" CLOB, "former incumbent" CLOB, "winner" CLOB, "cause" CLOB)

who resigned after richard ford ?
SELECT "former incumbent" FROM table_204_820 WHERE id = (SELECT id FROM table_204_820 WHERE "former incumbent" = 'richard ford') + 1
SELECT "former incumbent" FROM "table_204_820" WHERE "id" = (SELECT "id" FROM "table_204_820" WHERE "former incumbent" = 'richard ford') + 1