I am wondering if there is such a sequence of random variables $(X_n)_{n=0}^\infty$ such that $\mathbb{E}(X_{n+1}\mid X_n)=X_n$ for all $n\geq0$ but which is not a martingale with respect to the filtration $\mathcal{F_n}=\sigma(X_0, \dots, X_n)$.
I would really appreciate if you could show me such an example.
Let $(Y_j)_{j \in \mathbb{N}}$ be a sequence of identically distributed independent random variables such that $\mathbb{E}Y_j=0$. For some fixed $N \in \mathbb{N}$ we define
$$\begin{align*} X_n &:= \sum_{j=1}^n Y_j \qquad \text{for all} \, \, n \leq N \\ X_{n} &:= \sum_{j=1}^N Y_j + Y_1 - Y_2 = X_N+ Y_1-Y_2 \qquad \text{for all} \, \, n >N. \end{align*}$$
For $n \leq N$ and $n>N+1$, the condition
$$\mathbb{E}(X_{n} \mid X_{n-1}) = X_{n-1}$$
is obviously satisfied. For $n=N+1$, we have
$$\mathbb{E}(X_{N+1} \mid X_N) = X_N + \mathbb{E}(Y_1 \mid X_N) - \mathbb{E}(Y_2 \mid X_N). $$
Since $(Y_j)_{j \in \mathbb{N}}$ is identically distributed and independent, we have
$$\mathbb{E}(Y_1 \mid X_N) = \mathbb{E}(Y_2 \mid X_N)$$
and therefore
$$\mathbb{E}(X_{N+1} \mid X_N) = X_N.$$
On the other hand,
$$\begin{align*} \mathbb{E}(X_{N+1} \mid \mathcal{F}_N) &=X_N + 2\underbrace{\mathbb{E}(Y_1 \mid \mathcal{F}_N)}_{\mathbb{E}(X_1 \mid \mathcal{F}_N)=X_1} - \underbrace{\mathbb{E}(Y_1+Y_2 \mid \mathcal{F}_N)}_{\mathbb{E}(X_2 \mid \mathcal{F}_N) = X_2} \\ &= X_{N+1} \neq X_N. \end{align*}$$
Intuition: It is widely known that the process
$$S_n := \sum_{j=1}^n Y_j$$
can be used to model a fair game; the outcome of the $j$-th round is given by $Y_j$. Now we change the rules of our (fair) game: After $N$ rounds the game is stopped; in the final round the player gains the outcome of the first round, but loses the outcome of the second round. There are two cases: